﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Model;
using System.Data;
namespace DAL
{
    public class HouseMarkService
    {
        public  static int InsertHouseMark(HouseMark housemark) {

            string strSql = "insert into HouseMark values(" + housemark.ClientId + "," + housemark.HouseId + ")";
            return DBHelper.ExecuteCommand(strSql);
        }
        public static DataTable getAllHouseMarkByClientId(int clientID)
        {

            string strSql = "select * from HouseMark hm,House h "
              +" where hm.HouseId=h.Id and hm.ClientId="+clientID;
            return DBHelper.GetDataSet(strSql);
        }
    }
}
